Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Variant Code' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to VARIANT CODE

Seq No	Page Number	Page Name	Control Name
1	35	Item Translations	Variant Code
2	36	Assembly BOM	Variant Code
3	38	Item Ledger Entries	Variant Code
4	40	Item Journal	Variant Code
5	46	Sales Order Subform	Variant Code
6	47	Sales Invoice Subform	Variant Code
7	54	Purchase Order Subform	Variant Code
8	55	Purch. Invoice Subform	Variant Code
9	92	Job Ledger Entries	Variant Code
10	93	Job Ledger Entries Preview	Variant Code
11	95	Sales Quote Subform	Variant Code
12	96	Sales Cr. Memo Subform	Variant Code
13	97	Purchase Quote Subform	Variant Code
14	98	Purch. Cr. Memo Subform	Variant Code
15	114	Item Vendor Catalog	Variant Code
16	131	Posted Sales Shpt. Subform	Variant Code
17	133	Posted Sales Invoice Subform	Variant Code
18	135	Posted Sales Cr. Memo Subform	Variant Code
19	137	Posted Purchase Rcpt. Subform	Variant Code
20	139	Posted Purch. Invoice Subform	Variant Code
21	141	Posted Purch. Cr. Memo Subform	Variant Code
22	167	Item Ledger Entries Preview	Variant Code
23	171	Standard Sales Code Subform	Variant Code
24	176	Standard Purchase Code Subform	Variant Code
25	201	Job Journal	Variant Code
26	286	Recurring Item Jnl.	Variant Code
27	289	Recurring Job Jnl.	Variant Code
28	291	Req. Worksheet	Variant Code
29	296	Recurring Req. Worksheet	Variant Code
30	297	Vendor Item Catalog	Variant Code
31	298	Vendor Item List	Variant Code
32	305	Reservation Worksheet	Variant Code
33	390	Phys. Inventory Ledger Entries	Variant Code
34	392	Phys. Inventory Journal	Variant Code
35	393	Item Reclass. Journal	Variant Code
36	497	Reservation Entries	Variant Code
37	508	Blanket Sales Order Subform	Variant Code
38	510	Blanket Purchase Order Subform	Variant Code
39	516	Sales Lines	Variant Code
40	517	Requisition Lines	Variant Code
41	518	Purchase Lines	Variant Code
42	519	Item Journal Lines	Variant Code
43	521	Application Worksheet	Variant Code
44	522	View Applied Entries	Variant Code
45	525	Posted Sales Shipment Lines	Variant Code
46	526	Posted Sales Invoice Lines	Variant Code
47	527	Posted Sales Credit Memo Lines	Variant Code
48	528	Posted Purchase Receipt Lines	Variant Code
49	529	Posted Purchase Invoice Lines	Variant Code
50	530	Posted Purchase Cr. Memo Lines	Variant Code
51	755	Standard Item Journal Subform	Variant Code
52	900	Assembly Order	Variant Code
53	901	Assembly Order Subform	Variant Code
54	902	Assembly Orders	Variant Code
55	903	Assembly Lines	Variant Code
56	904	Assembly List	Variant Code
57	908	Assembly Availability	Variant Code
58	909	Assembly Line Avail.	Variant Code
59	914	Assemble-to-Order Lines	Variant Code
60	915	Asm.-to-Order Whse. Shpt. Line	Variant Code
61	920	Posted Assembly Order	Variant Code
62	921	Posted Assembly Order Subform	Variant Code
63	930	Assembly Quote	Variant Code
64	931	Assembly Quote Subform	Variant Code
65	932	Assembly Quotes	Variant Code
66	940	Blanket Assembly Order	Variant Code
67	941	Blanket Assembly Order Subform	Variant Code
68	942	Blanket Assembly Orders	Variant Code
69	1007	Job Planning Lines	Variant Code
70	1012	Job Item Prices	Variant Code
71	1345	Sales Price and Line Discounts	Variant Code
72	1346	Purchases Price and Line Disc.	Variant Code
73	1347	Sales Pr. & Line Disc. Part	Variant Code
74	2900	Demand Forecast Variant Matrix	Variant Code
75	5160	Sales Order Archive Subform	Variant Code
76	5163	Sales Quote Archive Subform	Variant Code
77	5165	Purchase Quote Archive Subform	Variant Code
78	5168	Purchase Order Archive Subform	Variant Code
79	5406	Prod. Order Line List	Variant Code
80	5407	Prod. Order Comp. Line List	Variant Code
81	5510	Production Journal	Variant Code
82	5522	Order Planning	Variant Code
83	5524	Get Alternative Supply	Variant Code
84	5530	Item Availability by Event	Variant Code
85	5700	Stockkeeping Unit Card	Variant Code
86	5701	Stockkeeping Unit List	Variant Code
87	5702	Stockkeeping Unit Comment List	Variant Code
88	5708	Get Shipment Lines	Variant Code
89	5709	Get Receipt Lines	Variant Code
90	5716	Item Substitution Entry	Variant Code
91	5718	Item Substitution Entries	Variant Code
92	5735	Item Reference List	Variant Code
93	5736	Item References	Variant Code
94	5737	Item Reference Entries	Variant Code
95	5741	Transfer Order Subform	Variant Code
96	5744	Posted Transfer Shpt. Subform	Variant Code
97	5746	Posted Transfer Rcpt. Subform	Variant Code
98	5769	Whse. Receipt Subform	Variant Code
99	5771	Whse. Put-away Subform	Variant Code
100	5772	Warehouse Pick Summary	Variant Code
101	5780	Whse. Pick Subform	Variant Code
102	5783	Cross-Dock Opportunities	Variant Code
103	5785	Warehouse Activity Lines	Variant Code
104	5796	Registered Put-away Subform	Variant Code
105	5799	Registered Pick Subform	Variant Code
106	5803	Revaluation Journal	Variant Code
107	5804	Applied Item Entries	Variant Code
108	5806	Purch. Receipt Lines	Variant Code
109	5824	Sales Shipment Lines	Variant Code
110	5830	Demand Overview	Variant Code
111	5832	Capacity Ledger Entries	Variant Code
112	5847	Average Cost Calc. Overview	Variant Code
113	5847	Average Cost Calc. Overview	Variant Code
114	5851	Get Post.Doc – S.ShptLn Sbfrm	Variant Code
115	5852	Get Post.Doc – S.InvLn Subform	Variant Code
116	5853	Get Pst.Doc-RtrnRcptLn Subform	Variant Code
117	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Variant Code
118	5856	Get Post.Doc – P.RcptLn Sbfrm	Variant Code
119	5857	Get Post.Doc – P.InvLn Subform	Variant Code
120	5858	Get Pst.Doc-RtrnShptLn Subform	Variant Code
121	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Variant Code
122	5870	BOM Structure	Variant Code
123	5871	Item Availability by BOM Level	Variant Code
124	5872	BOM Cost Shares	Variant Code
125	5877	Physical Inventory Order Subf.	Variant Code
126	5878	Physical Inventory Order Lines	Variant Code
127	5881	Phys. Invt. Recording Subform	Variant Code
128	5882	Phys. Invt. Recording Lines	Variant Code
129	5885	Posted Phys. Invt. Order Subf.	Variant Code
130	5886	Posted Phys. Invt. Order Lines	Variant Code
131	5889	Posted Phys. Invt. Rec. Subf.	Variant Code
132	5890	Posted Phys. Invt. Rec. Lines	Variant Code
133	5893	Phys. Invt. Item Track. List	Variant Code
134	5894	Posted Phys. Invt. Tracking	Variant Code
135	5902	Service Order Subform	Variant Code
136	5905	Service Lines	Variant Code
137	5907	Service Item Worksheet Subform	Variant Code
138	5915	Service Tasks	Variant Code
139	5934	Service Invoice Subform	Variant Code
140	5936	Service Credit Memo Subform	Variant Code
141	5951	Posted Service Invoice Lines	Variant Code
142	5952	Posted Service Cr. Memo Lines	Variant Code
143	5956	Standard Service Code Subform	Variant Code
144	5966	Service Quote Lines	Variant Code
145	5973	Posted Serv. Cr. Memo Subform	Variant Code
146	5976	Posted Service Shpt. Subform	Variant Code
147	5979	Posted Service Invoice Subform	Variant Code
148	5980	Service Item Card	Variant Code
149	5986	Service Item Component List	Variant Code
150	5994	Get Service Shipment Lines	Variant Code
151	6036	Service Lines Subform	Variant Code
152	6037	Service Shipment Lines Subform	Variant Code
153	6038	Service Invoice Lines Subform	Variant Code
154	6039	Service Cr. Memo Lines Subform	Variant Code
155	6052	Service Contract Subform	Variant Code
156	6054	Service Contract Quote Subform	Variant Code
157	6078	Service Contract Line List	Variant Code
158	6501	Item Tracking Entries	Variant Code
159	6504	Serial No. Information Card	Variant Code
160	6505	Lot No. Information Card	Variant Code
161	6508	Lot No. Information List	Variant Code
162	6509	Serial No. Information List	Variant Code
163	6510	Item Tracking Lines	Variant Code
164	6516	Package No. Information List	Variant Code
165	6520	Item Tracing	Variant Code
166	6526	Package No. Information Card	Variant Code
167	6550	Whse. Item Tracking Lines	Variant Code
168	6562	Invt. Receipt Subform	Variant Code
169	6565	Invt. Shipment Subform	Variant Code
170	6568	Posted Invt. Receipt Subform	Variant Code
171	6571	Posted Invt. Shipment Subform	Variant Code
172	6619	Sales Line Archive List	Variant Code
173	6621	Blanket Sales Order Arch. Sub.	Variant Code
174	6624	Blanket Purch. Order Arch.Sub.	Variant Code
175	6626	Purchase Line Archive List	Variant Code
176	6628	Sales Return Order Arc Subform	Variant Code
177	6631	Sales Return Order Subform	Variant Code
178	6638	Get Return Receipt Lines	Variant Code
179	6641	Purchase Return Order Subform	Variant Code
180	6645	Purch Return Order Arc Subform	Variant Code
181	6648	Get Return Shipment Lines	Variant Code
182	6651	Posted Return Shipment Subform	Variant Code
183	6653	Posted Return Shipment Lines	Variant Code
184	6657	Return Shipment Lines	Variant Code
185	6661	Posted Return Receipt Subform	Variant Code
186	6663	Posted Return Receipt Lines	Variant Code
187	6667	Return Receipt Lines	Variant Code
188	6774	Invt. Document Lines	Variant Code
189	6782	Posted Direct Transfer Subform	Variant Code
190	7001	Price List Lines	Variant Code
191	7002	Sales Prices	Variant Code
192	7003	Duplicate Price Lines	Variant Code
193	7004	Sales Line Discounts	Variant Code
194	7005	Price List Line Review	Variant Code
195	7007	Get Sales Price	Variant Code
196	7009	Get Sales Line Disc.	Variant Code
197	7010	Get Price Line	Variant Code
198	7011	Purchase Price List Lines	Variant Code
199	7012	Purchase Prices	Variant Code
200	7014	Purchase Line Discounts	Variant Code
201	7022	Price Worksheet	Variant Code
202	7023	Sales Price Worksheet	Variant Code
203	7023	Sales Price Worksheet	Variant Code
204	7024	Prices Overview	Variant Code
205	7189	Get Purchase Line Disc.	Variant Code
206	7190	Get Purchase Price	Variant Code
207	7304	Bin Content	Variant Code
208	7304	Bin Content	Variant Code
209	7305	Bin Contents List	Variant Code
210	7316	Warehouse Movement Subform	Variant Code
211	7318	Warehouse Entries	Variant Code
212	7319	Warehouse Journal Lines	Variant Code
213	7324	Whse. Item Journal	Variant Code
214	7326	Whse. Phys. Invt. Journal	Variant Code
215	7331	Posted Whse. Receipt Subform	Variant Code
216	7336	Whse. Shipment Subform	Variant Code
217	7338	Posted Whse. Shipment Subform	Variant Code
218	7341	Whse. Shipment Lines	Variant Code
219	7342	Whse. Receipt Lines	Variant Code
220	7345	Pick Worksheet	Variant Code
221	7350	Registered Movement Subform	Variant Code
222	7351	Movement Worksheet	Variant Code
223	7352	Put-away Worksheet	Variant Code
224	7355	Internal Put-away Subform	Variant Code
225	7358	Whse. Internal Pick Line	Variant Code
226	7358	Whse. Internal Pick Line	Variant Code
227	7360	Whse. Internal Pick Lines	Variant Code
228	7361	Whse. Internal Put-away Lines	Variant Code
229	7362	Posted Whse. Shipment Lines	Variant Code
230	7363	Posted Whse. Receipt Lines	Variant Code
231	7364	Registered Whse. Act.-Lines	Variant Code
232	7365	Whse. Reclassification Journal	Variant Code
233	7371	Bin Content Creation Worksheet	Variant Code
234	7374	Bin Contents	Variant Code
235	7376	Invt. Put-away Subform	Variant Code
236	7378	Invt. Pick Subform	Variant Code
237	7379	Item Bin Contents	Variant Code
238	7380	Phys. Invt. Item Selection	Variant Code
239	7380	Phys. Invt. Item Selection	Variant Code
240	7383	Invt. Movement Subform	Variant Code
241	7385	Reg. Invt. Movement Subform	Variant Code
242	7387	Reg. Invt. Movement Lines	Variant Code
243	7391	Posted Invt. Put-away Subform	Variant Code
244	7393	Posted Invt. Pick Subform	Variant Code
245	7396	Posted Invt. Put-away Lines	Variant Code
246	7397	Posted Invt. Pick Lines	Variant Code
247	7398	Internal Movement Subform	Variant Code
248	7706	Item Identifiers	Variant Code
249	7707	Item Identifiers List	Variant Code
250	9101	Untracked Plng. Elements Part	Variant Code
251	9287	Prod. BOM Mat. per Ver. Matrix	Variant Code
252	30139	Shpfy Fulfillment Order Lines	Variant Code
253	30146	Shpfy Refund Lines	Variant Code
254	30149	Shpfy Return Lines	Variant Code
255	99000788	Production BOM Lines	Variant Code
256	99000789	Production BOM Version Lines	Variant Code
257	99000813	Planned Production Order	Variant Code
258	99000814	Planned Prod. Order Lines	Variant Code
259	99000818	Prod. Order Components	Variant Code
260	99000823	Output Journal	Variant Code
261	99000827	Recurring Output Journal	Variant Code
262	99000829	Firm Planned Prod. Order	Variant Code
263	99000830	Firm Planned Prod. Order Lines	Variant Code
264	99000831	Released Production Order	Variant Code
265	99000832	Released Prod. Order Lines	Variant Code
266	99000846	Consumption Journal	Variant Code
267	99000850	Recurring Consumption Journal	Variant Code
268	99000852	Planning Worksheet	Variant Code
269	99000855	Untracked Planning Elements	Variant Code
270	99000860	Planning Worksheet Line List	Variant Code
271	99000861	Planning Component List	Variant Code
272	99000862	Planning Components	Variant Code
273	99000867	Finished Production Order	Variant Code
274	99000868	Finished Prod. Order Lines	Variant Code
275	99000883	Sales Order Planning	Variant Code
276	99000912	Simulated Production Order	Variant Code
277	99000913	Simulated Prod. Order Lines	Variant Code
278	99000922	Demand Forecast Entries	Variant Code

Dynamics 365 BC Table ReferencePage Control Search